package com.night.xjh.mapper;


import com.night.common.entity.xjh.Visit;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @ClassName: VisitMapper
 * @Description: //TODO
 * @author: xjh
 * @date: 2022/10/18-17:35
 * @version: v1.0
 */
public interface VisitMapper {
    List<Visit> getAll();
    Visit getById(int id);
    List<Visit> getByCondition(@Param("visit") Visit visit);
    //再写个时间段查询的
    List<Visit> getByDate(@Param("startDate")String startDate,@Param("endDate")String endDate);
    void add(Visit visit);
    void deleteById(int id);
    void update(Visit visit);
    //select * from ss_visit where visit_date in(SELECT visit_date from ss_visit GROUP BY visit_date having count(visit_date)>1)
    //查询到访时间相同的数据
}
